package com.fengxing.ams.web.facade.mouble.order;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.springframework.data.repository.query.Param;

public interface IStatusFlowDAO extends PagingAndSortingRepository<StatusFlowVO, Integer>, JpaSpecificationExecutor<StatusFlowVO>  {

	@Query(value="select * from zyt_status_flow where status=:status and type=:type", nativeQuery=true)
	StatusFlowVO findNextStatus(@Param("status")Integer status, @Param("type")Integer type);
	
}
